CustomerTradeAccount

Entity Definition

Logical Name : CustomerTradeAccount
Physical Name : LE_ACNT_CT_TRD

A type of CUSTOMER ACCOUNT established for builders, plumbers, electricians and other trade businesses that purchase merchandise, usually at a preferential discount, from the store. A CustomerTradeAccount grants credit to customers on an invoice by invoice basis with the expectation that each invoice will be paid in full. It is different from a revolving charge account which carries an aggregate credit balance from period to period.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type
CustomerAccountID (FK)(PK)	A unique identifier for a customer account.	ID_CTAC	Identity	integer
DiscountMonetaryAmount	The monetary amount of discount provided to a specific CUSTOMER TRADE ACCOUNT.	MO_DSC_CT_TRD	Money	decimal(16,5)
DiscountPercent	The percentage of the base retail price discount provided to a specific CUSTOMER TRADE ACCOUNT.	PE_DSC_CT_TRD	Percent	decimal(7,4)
PaymentDueDayCount	The number of days after an invoice date that the invoice must be paid. Invoices paid after their payment due date may (depending on the terms and conditions of the trade account and invoice) incur and interest charge.	DI_PYM_DUE_DY_CNT	QuantityDayCount	decimal(3,0)
AnnualInterestRatePercent	Tha annual interest rate percent charged on late invoice balances. Annual rates may be expressed in monthlly or daily rates.	PE_ANN_INTRST_RT_PE	Percent	decimal(7,4)
EarlyPaymentDiscountDayCount	The number of days after an invoice that grant the customer a discount for early payment of an invoice. For example terms 1.5% NET 20 means that if a customer pays an invoice within 20 days it can take a 1.5% discount off of its payment.	DI_ERLY_PYM_DY_CNT	QuantityDayCount	decimal(3,0)

Relationships

Parent Entity	Verb Phrase	Child Entity
CustomerAccount	can be a	CustomerTradeAccount

Logical Views containing CustomerTradeAccount

Logical View
Logical 07010 - Customer Account Information Extended